Michigan PFAS Data

Data summary

Name	pfas_sites
Number of rows	300
Number of columns	20
_______________________
Column type frequency:
character	16
numeric	4
________________________
Group variables	None

Variable type: character

skim_variable	n_missing	complete_rate	min	max	empty	n_unique	whitespace
facility	0	1.00	9	103	0	300	0
county	0	1.00	10	26	0	76	0
address	1	1.00	4	88	0	299	0
city	1	1.00	4	29	0	174	0
type	0	1.00	7	22	0	15	0
residential_wells_sampled	0	1.00	2	3	0	4	0
site_lead	0	1.00	9	65	0	107	0
site_lead_email	0	1.00	15	27	0	128	0
site_lead_phone	0	1.00	12	16	0	105	0
hyperlink	0	1.00	84	134	0	293	0
location	115	0.62	4	25	0	128	0
military	0	1.00	2	4	0	3	0
facility_date	8	0.97	22	22	0	190	0
site_background	265	0.12	626	3752	0	35	0
drinking_water_information	265	0.12	95	2098	0	35	0
anticipated_activities	265	0.12	15	397	0	35	0

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
geoid	0	1	26088.58	45.84	26001.00	26049.00	26081.00	26125.00	26163.00	▃▅▇▆▆
longitude	0	1	-84.82	1.32	-90.13	-85.70	-84.76	-83.66	-82.44	▁▁▇▅▇
latitude	0	1	43.24	1.12	41.78	42.48	42.95	43.54	47.46	▇▆▂▁▁
zip_code	0	1	49003.64	3935.16	20020.00	48453.50	48911.00	49442.25	94105.00	▁▇▁▁▁

Data summary

Name	surface_water_long
Number of rows	208548
Number of columns	26
_______________________
Column type frequency:
character	20
numeric	6
________________________
Group variables	None

Variable type: character

skim_variable	n_missing	complete_rate	min	max	empty	n_unique	whitespace
geoid	3024	0.99	5	5	0	70	0
lab_sample_id	108	1.00	6	12	0	1797	0
site_code	0	1.00	9	13	0	1349	0
coc_sample_id	7344	0.96	1	26	0	1537	0
sample_type	186624	0.11	6	16	0	5	0
lab_name	0	1.00	4	25	0	17	0
lab_job_name	16308	0.92	7	12	0	166	0
collection_date	0	1.00	22	22	0	198	0
analysis_method	108	1.00	4	29	0	10	0
analysis_date	25596	0.88	22	22	0	216	0
watershed	0	1.00	4	21	0	52	0
waterbody	108	1.00	5	31	0	589	0
location_code	0	1.00	6	10	0	1205	0
huc10	21708	0.90	9	10	0	153	0
huc8	0	1.00	8	8	0	55	0
project	0	1.00	4	13	0	2	0
description	216	1.00	2	53	0	1241	0
additional_description	121824	0.42	5	69	0	413	0
sample_depth	206712	0.01	6	10	0	3	0
analyte	0	1.00	14	25	0	108	0

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
longitude	0	1.00	-84.86	1.75	-90.18	-85.85	-84.46	-83.54	-82.43	▁▂▃▅▇
latitude	0	1.00	43.60	1.57	41.76	42.47	43.02	44.42	47.47	▇▆▁▂▂
dilution_factor	16416	0.92	1.32	3.36	0.00	1.00	1.00	1.00	100.00	▇▁▁▁▁
duplicate	0	1.00	1.11	0.34	1.00	1.00	1.00	1.00	3.00	▇▁▁▁▁
visit_id	24516	0.88	2019889.60	1729.85	2013001.00	2019005.00	2020206.00	2021213.00	2022021.00	▁▁▃▇▇
analyte_value	53414	0.74	3.42	59.55	0.10	0.81	1.17	2.00	11000.00	▇▁▁▁▁

Data summary

Name	public_water_wide
Number of rows	16109
Number of columns	50
_______________________
Column type frequency:
character	16
logical	10
numeric	24
________________________
Group variables	None

Variable type: character

skim_variable	n_missing	complete_rate	min	max	empty	n_unique	whitespace
geoid	824	0.95	5	5	0	87	0
system_name	274	0.98	3	59	0	4727	0
system_type	0	1.00	3	7	0	12	0
loc_name	4691	0.71	1	31	0	274	0
sys_loc_code	10695	0.34	12	20	0	3408	0
position_source	4	1.00	4	4	0	2	0
phase_code	10695	0.34	7	15	0	7	0
task_code	0	1.00	6	12	0	21	0
task_type	0	1.00	8	9	0	2	0
sample_date	0	1.00	22	22	0	3623	0
treatment_status	10769	0.33	2	7	0	6	0
sys_sample_code	0	1.00	5	20	0	15928	0
lab_name_code	0	1.00	3	40	0	43	0
lab_number	5414	0.66	4	4	0	28	0
lab_sdg	10695	0.34	6	8	0	4110	0
analytical_method	0	1.00	7	9	0	3	0

Variable type: logical

skim_variable	n_missing	complete_rate	mean	count
FTSA42Result	16109	0	NaN	:
FTSA62Result	16109	0	NaN	:
FTSA82Result	16109	0	NaN	:
FOSAResult	16109	0	NaN	:
PFBAResult	16109	0	NaN	:
PFDSResult	16109	0	NaN	:
PFHpSResult	16109	0	NaN	:
PFNSResult	16109	0	NaN	:
PFPeAResult	16109	0	NaN	:
PFPeSResult	16109	0	NaN	:

Variable type: numeric

skim_variable	n_missing	complete_rate	mean	sd	p0	p25	p50	p75	p100	hist
longitude	0	1.00	-84.87	1.26	-90.17	-85.67	-84.88	-83.78	-82.38	▁▁▆▇▆
latitude	0	1.00	43.37	1.24	41.72	42.48	42.96	44.05	47.47	▇▅▂▂▁
object_id	0	1.00	8055.00	4650.41	1.00	4028.00	8055.00	12082.00	16109.00	▇▇▇▇▇
hex_id	0	1.00	805.05	474.76	1.00	381.00	813.00	1222.00	1610.00	▇▇▇▇▇
wssn	3	1.00	1058800.42	3078921.71	0.00	4090.00	40333.00	2022013.00	55293901.00	▇▁▁▁▁
sampling_results_count	0	1.00	22.35	22.14	1.00	8.00	16.00	27.00	130.00	▇▂▁▁▁
HFPODAResult	10686	0.34	0.06	2.20	0.00	0.00	0.00	0.00	100.00	▇▁▁▁▁
PFBSResult	9883	0.39	1.75	7.42	0.00	0.00	0.00	0.00	230.00	▇▁▁▁▁
PFHxAResult	10134	0.37	1.20	4.75	0.00	0.00	0.00	0.00	111.00	▇▁▁▁▁
PFHxSResult	10226	0.37	1.55	11.35	0.00	0.00	0.00	0.00	347.00	▇▁▁▁▁
PFNAResult	10628	0.34	0.08	0.99	0.00	0.00	0.00	0.00	34.00	▇▁▁▁▁
PFOAResult	10124	0.37	1.35	14.35	0.00	0.00	0.00	0.00	780.00	▇▁▁▁▁
PFOSResult	10195	0.37	1.42	15.03	0.00	0.00	0.00	0.00	740.00	▇▁▁▁▁
PF3OUdS11ClResult	10693	0.34	0.00	0.04	0.00	0.00	0.00	0.00	3.00	▇▁▁▁▁
PF3ONS9ClResult	10693	0.34	0.00	0.03	0.00	0.00	0.00	0.00	2.00	▇▁▁▁▁
ADONAResult	10694	0.34	0.00	0.01	0.00	0.00	0.00	0.00	1.00	▇▁▁▁▁
NEtFOSAAResult	10652	0.34	0.11	2.71	0.00	0.00	0.00	0.00	110.00	▇▁▁▁▁
NMeFOSAAResult	10661	0.34	0.31	14.23	0.00	0.00	0.00	0.00	860.00	▇▁▁▁▁
PFDAResult	10680	0.34	0.06	2.18	0.00	0.00	0.00	0.00	93.00	▇▁▁▁▁
PFDoDAResult	10692	0.34	0.00	0.10	0.00	0.00	0.00	0.00	6.00	▇▁▁▁▁
PFHpAResult	10491	0.35	0.40	2.94	0.00	0.00	0.00	0.00	150.00	▇▁▁▁▁
PFTeDAResult	10693	0.34	0.00	0.06	0.00	0.00	0.00	0.00	4.00	▇▁▁▁▁
PFTrDAResult	10679	0.34	0.01	0.25	0.00	0.00	0.00	0.00	8.00	▇▁▁▁▁
PFUnDAResult	10679	0.34	0.07	1.56	0.00	0.00	0.00	0.00	63.00	▇▁▁▁▁

Rows: 16,109
Columns: 50
$ geoid                  <chr> "26139", "26139", "26139", "26139", "26139", "2…
$ longitude              <dbl> -85.82290, -85.82290, -85.82290, -85.82290, -85…
$ latitude               <dbl> 43.04939, 43.04939, 43.04939, 43.04939, 43.0493…
$ object_id              <dbl> 1, 1367, 1368, 8100, 8101, 8102, 8103, 12398, 1…
$ hex_id                 <dbl> 1407, 1407, 1407, 1407, 1407, 1407, 1407, 1407,…
$ system_name            <chr> "1239 Comstock LLC.", "Dewys Manufacturing", "D…
$ wssn                   <dbl> 2043570, 2048770, 2054870, 2048770, 2048770, 20…
$ system_type            <chr> "INDUS", "INDUS", "INDUS", "MUN", "MUN", "MUN",…
$ loc_name               <chr> "LOC01", "LOC01", "LOC02", NA, NA, NA, NA, NA, …
$ sys_loc_code           <chr> "INDUS-023-LOC01", "INDUS-089-LOC01", "INDUS-08…
$ position_source        <chr> "EGLE", "EGLE", "YUMA", "EGLE", "EGLE", "EGLE",…
$ phase_code             <chr> "PHASE_2", "PHASE_2", "PHASE_2", NA, NA, NA, NA…
$ task_code              <chr> "PHASE_2", "PHASE_2", "PHASE_2", "ComplMon", "C…
$ task_type              <chr> "StateSurv", "StateSurv", "StateSurv", "ComplMo…
$ sample_date            <chr> "2019/05/17 00:00:00+00", "2019/05/17 00:00:00+…
$ treatment_status       <chr> "Treated", "Raw", "Raw", NA, NA, NA, NA, NA, NA…
$ sys_sample_code        <chr> "GWEF1905170855RL", "GWNT1905170930RL", "GWNT19…
$ lab_name_code          <chr> "VAL", "VAL", "VAL", "Prein-Newhof", "Prein-New…
$ lab_number             <chr> NA, NA, NA, "0020", "0020", "0020", "0020", "00…
$ lab_sdg                <chr> "1901207", "1901207", "1901207", NA, NA, NA, NA…
$ analytical_method      <chr> "EPA-537", "EPA-537", "EPA-537", "EPA 537.1", "…
$ sampling_results_count <dbl> 17, 17, 17, 17, 17, 17, 17, 17, 17, 17, 17, 17,…
$ HFPODAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFBSResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHxAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHxSResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFNAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFOAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFOSResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PF3OUdS11ClResult      <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PF3ONS9ClResult        <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ ADONAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ FTSA42Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FTSA62Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FTSA82Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FOSAResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ NEtFOSAAResult         <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ NMeFOSAAResult         <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFBAResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFDAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFDoDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFDSResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFHpAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHpSResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFNSResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFPeAResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFPeSResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFTeDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFTrDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFUnDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…

# A tibble: 5 × 51
  geoid longitude latitude object_id hex_id system_name         wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>              <dbl> <chr>      
1 26139     -85.8     43.0         1   1407 1239 Comstock LL… 2.04e6 INDUS      
2 26139     -85.8     43.0      1367   1407 Dewys Manufactur… 2.05e6 INDUS      
3 26139     -85.8     43.0      1368   1407 Dewys Manufactur… 2.05e6 INDUS      
4 26139     -85.8     43.0      8100   1407 DEWYS MANUFACTUR… 2.05e6 MUN        
5 26139     -85.8     43.0      8101   1407 DEWYS MANUFACTUR… 2.05e6 MUN        
# ℹ 43 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, HFPODAResult <dbl>,
#   PFBSResult <dbl>, PFHxAResult <dbl>, PFHxSResult <dbl>, PFNAResult <dbl>,
#   PFOAResult <dbl>, PFOSResult <dbl>, PF3OUdS11ClResult <dbl>, …

hex_id	Hazard_Index	HFPODAResult	PFNAResult	PFBSResult	PFHxSResult
234	34.72050	0	0	41.0	347
234	31.33150	0	0	63.0	313
234	31.01750	0	0	35.0	310
234	30.11750	0	0	35.0	301
234	27.01300	0	0	26.0	270
234	24.81200	0	0	24.0	248
234	22.51550	0	0	31.0	225
234	22.21250	0	0	25.0	222
394	10.00000	100	0	0.0	0
553	9.30000	93	0	0.0	0
1,114	8.70000	87	0	0.0	0
5	6.71500	0	0	30.0	67
37	6.20300	0	0	6.0	62
37	5.80250	0	0	5.0	58
5	5.11100	0	0	22.0	51
1,177	5.10000	0	0	0.0	51
5	4.91350	0	0	27.0	49
37	4.90250	0	0	5.0	49
37	4.90250	0	0	5.0	49
1,562	4.80600	0	8	12.0	40
1,177	4.80000	0	0	0.0	48
5	4.61150	0	0	23.0	46
766	4.50100	0	34	2.0	11
1,177	4.30000	0	0	0.0	43
766	4.20000	0	32	0.0	10
1,177	4.10000	0	0	0.0	41
1,177	4.00000	0	0	0.0	40
250	4.00000	0	0	0.0	40
124	3.90150	0	0	3.0	39
124	3.80200	0	0	4.0	38
1,177	3.70000	0	0	0.0	37
1,440	3.60400	0	0	8.0	36
1,152	3.60300	0	0	6.0	36
1,152	3.60220	0	0	4.4	36
124	3.60150	0	0	3.0	36
124	3.60150	0	0	3.0	36
124	3.60150	0	0	3.0	36
124	3.60150	0	0	3.0	36
1,152	3.50250	0	0	5.0	35
37	3.50200	0	0	4.0	35
37	3.50200	0	0	4.0	35
124	3.50150	0	0	3.0	35
124	3.50150	0	0	3.0	35
124	3.40150	0	0	3.0	34
1,177	3.40000	0	0	0.0	34
124	3.30150	0	0	3.0	33
5	3.21950	0	0	39.0	32
419	3.20350	0	0	7.0	32
1,152	3.20250	0	0	5.0	32
1,275	3.20190	0	0	3.8	32
1,275	3.20190	0	0	3.8	32
124	3.20150	0	0	3.0	32
124	3.20150	0	0	3.0	32
766	3.20100	0	20	2.0	12
1,177	3.20000	0	0	0.0	32
419	3.10350	0	0	7.0	31
1,440	3.10300	0	0	6.0	31
1,440	3.00300	0	0	6.0	30
1,440	3.00300	0	0	6.0	30
1,440	3.00250	0	0	5.0	30
1,152	3.00250	0	0	5.0	30
1,177	3.00000	0	0	0.0	30
1,177	3.00000	0	0	0.0	30
1,177	3.00000	0	0	0.0	30
766	3.00000	0	19	0.0	11
1,152	2.90200	0	0	4.0	29
37	2.90150	0	0	3.0	29
37	2.90150	0	0	3.0	29
124	2.90150	0	0	3.0	29
766	2.90100	0	17	2.0	12
1,152	2.80300	0	0	6.0	28
1,152	2.80200	0	0	4.0	28
124	2.80150	0	0	3.0	28
124	2.80150	0	0	3.0	28
766	2.80000	0	18	0.0	10
5	2.71650	0	0	33.0	27
5	2.70750	0	0	15.0	27
5	2.70150	0	0	3.0	27
766	2.70150	0	0	3.0	27
1,440	2.60300	0	0	6.0	26
124	2.60150	0	0	3.0	26
124	2.60150	0	0	3.0	26
124	2.60150	0	0	3.0	26
1,562	2.50350	0	6	7.0	19
1,152	2.40250	0	0	5.0	24
5	2.40250	0	0	5.0	24
766	2.40100	0	8	2.0	16
1,177	2.40000	0	0	0.0	24
5	2.31450	0	0	29.0	23
296	2.30000	0	0	0.0	23
37	2.20250	0	0	5.0	22
1,377	2.20000	0	0	0.0	22
296	2.20000	0	0	0.0	22
293	2.20000	0	0	0.0	22
205	2.10250	0	0	5.0	21
37	2.10100	0	0	2.0	21
205	2.10100	0	0	2.0	21
766	2.10000	0	0	0.0	21
296	2.10000	0	0	0.0	21
5	2.00700	0	0	14.0	20
419	2.00250	0	0	5.0	20
205	2.00000	0	0	0.0	20
296	2.00000	0	0	0.0	20
299	1.91450	0	0	29.0	19
37	1.90200	0	0	4.0	19
296	1.90150	0	0	3.0	19
1,521	1.90115	0	0	2.3	19
250	1.90000	0	0	0.0	19
296	1.90000	0	0	0.0	19
205	1.80300	0	0	6.0	18
205	1.80250	0	0	5.0	18
296	1.80250	0	0	5.0	18
1,003	1.80200	0	0	4.0	18
419	1.80200	0	0	4.0	18
419	1.80200	0	0	4.0	18
124	1.80150	0	0	3.0	18
37	1.80100	0	0	2.0	18
1,521	1.80000	0	0	0.0	18
1,348	1.80000	0	0	0.0	18
205	1.80000	0	0	0.0	18
205	1.80000	0	0	0.0	18
296	1.80000	0	0	0.0	18
296	1.80000	0	0	0.0	18
1,562	1.70400	0	0	8.0	17
5	1.70250	0	0	5.0	17
1,263	1.70200	0	0	4.0	17
37	1.70150	0	0	3.0	17
296	1.70150	0	0	3.0	17
296	1.70150	0	0	3.0	17
205	1.70100	0	0	2.0	17
766	1.70100	0	3	2.0	14
766	1.70000	0	6	0.0	11
1,348	1.70000	0	0	0.0	17
766	1.70000	0	7	0.0	10
1,440	1.60250	0	0	5.0	16
419	1.60200	0	0	4.0	16
124	1.60100	0	0	2.0	16
1,177	1.60000	0	0	0.0	16
1,177	1.60000	0	0	0.0	16
1,177	1.60000	0	0	0.0	16
766	1.60000	0	8	0.0	8
293	1.60000	0	0	0.0	16
360	1.50200	0	0	4.0	15
37	1.50150	0	0	3.0	15
124	1.50150	0	0	3.0	15
766	1.50150	0	5	3.0	10
37	1.50100	0	0	2.0	15
766	1.50100	0	0	2.0	15
766	1.50100	0	0	2.0	15
766	1.50100	0	0	2.0	15
766	1.50100	0	3	2.0	12
296	1.50100	0	0	2.0	15
296	1.50100	0	0	2.0	15
296	1.50100	0	0	2.0	15
37	1.50000	0	0	0.0	15
5	1.41000	0	0	20.0	14
360	1.40250	0	0	5.0	14
360	1.40250	0	0	5.0	14
360	1.40200	0	0	4.0	14
1,076	1.40150	0	14	3.0	0
1,304	1.40150	0	0	3.0	14
296	1.40150	0	0	3.0	14
1,377	1.40100	0	0	2.0	14
419	1.40100	0	0	2.0	14
124	1.40100	0	0	2.0	14
171	1.40100	0	0	2.0	14
124	1.40000	0	0	0.0	14
293	1.40000	0	0	0.0	14
293	1.40000	0	0	0.0	14
360	1.30200	0	0	4.0	13
1,263	1.30150	0	0	3.0	13
124	1.30100	0	0	2.0	13
1,386	1.20950	0	0	19.0	12
1,386	1.20950	0	0	19.0	12
515	1.20300	0	0	6.0	12
515	1.20250	0	0	5.0	12
205	1.20250	0	0	5.0	12
205	1.20150	0	0	3.0	12
124	1.20100	0	0	2.0	12
296	1.20100	0	0	2.0	12
1,377	1.20000	0	0	0.0	12
1,177	1.20000	0	0	0.0	12
1,492	1.20000	0	0	0.0	12
1,386	1.11050	0	0	21.0	11
1,386	1.11050	0	0	21.0	11
299	1.10900	0	0	18.0	11
1,386	1.10900	0	0	18.0	11
5	1.10850	0	0	17.0	11
5	1.10850	0	0	17.0	11
1,304	1.10100	0	0	2.0	11
296	1.10100	0	0	2.0	11
1,521	1.10000	0	0	0.0	11
1,377	1.10000	0	0	0.0	11
1,377	1.10000	0	0	0.0	11
1,177	1.10000	0	0	0.0	11
1,177	1.10000	0	0	0.0	11
78	1.10000	0	0	0.0	11
766	1.10000	0	0	0.0	11
171	1.10000	0	0	0.0	11
293	1.10000	0	0	0.0	11
299	1.00950	0	0	19.0	10
1,386	1.00950	0	0	19.0	10
5	1.00750	0	0	15.0	10
5	1.00700	0	0	14.0	10
5	1.00700	0	0	14.0	10
5	1.00700	0	0	14.0	10
296	1.00650	0	0	13.0	10
374	1.00450	0	0	9.0	10
515	1.00150	0	0	3.0	10
431	1.00150	0	0	3.0	10

# A tibble: 5 × 51
  geoid longitude latitude object_id hex_id system_name         wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>              <dbl> <chr>      
1 26129     -84.1     44.2      1090      1 Cole Canoe Base   2.00e6 CHLCMP     
2 26051     -84.4     44.1      2765      2 Lakeside Develop… 3.75e3 MUN        
3 26157     -83.5     43.7      5031      3 Usa Elementary S… 2.03e6 SCH        
4 26125     -83.2     42.6      1098      4 College Heights … 4.04e4 MUN        
5 26139     -86.1     43.0      4257      5 Robinson Element… 2.03e6 SCH        
# ℹ 43 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, HFPODAResult <dbl>,
#   PFBSResult <dbl>, PFHxAResult <dbl>, PFHxSResult <dbl>, PFNAResult <dbl>,
#   PFOAResult <dbl>, PFOSResult <dbl>, PF3OUdS11ClResult <dbl>, …

hex_id	Hazard_Index	HFPODAResult	PFNAResult	PFBSResult	PFHxSResult
234	34.72050	0	0	41.0	347
394	10.00000	100	0	0.0	0
553	9.30000	93	0	0.0	0
1,114	8.70000	87	0	0.0	0
5	6.71500	0	0	30.0	67
37	6.20300	0	0	6.0	62
1,177	5.10000	0	0	0.0	51
1,562	4.80600	0	8	12.0	40
766	4.50100	0	34	2.0	11
250	4.00000	0	0	0.0	40
124	3.90150	0	0	3.0	39
1,440	3.60400	0	0	8.0	36
1,152	3.60300	0	0	6.0	36
419	3.20350	0	0	7.0	32
1,275	3.20190	0	0	3.8	32
296	2.30000	0	0	0.0	23
293	2.20000	0	0	0.0	22
1,377	2.20000	0	0	0.0	22
205	2.10250	0	0	5.0	21
299	1.91450	0	0	29.0	19
1,521	1.90115	0	0	2.3	19
1,003	1.80200	0	0	4.0	18
1,348	1.80000	0	0	0.0	18
1,263	1.70200	0	0	4.0	17
360	1.50200	0	0	4.0	15
1,076	1.40150	0	14	3.0	0
1,304	1.40150	0	0	3.0	14
171	1.40100	0	0	2.0	14
1,386	1.20950	0	0	19.0	12
515	1.20300	0	0	6.0	12
1,492	1.20000	0	0	0.0	12
78	1.10000	0	0	0.0	11
374	1.00450	0	0	9.0	10
431	1.00150	0	0	3.0	10

# A tibble: 5 × 25
  geoid longitude latitude object_id hex_id system_name        wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>             <dbl> <chr>      
1 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
2 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
3 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
4 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
5 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
# ℹ 17 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, Hazard_Index <dbl>,
#   analyte <chr>, analyte_value <dbl>

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

System Type	Total Hazard	Number of Sites
Community Water Supply (for example Municipal Supply, Apartment, Nursing Home, Prison, etc.)	145.2770	985
School	22.6660	234
Non-Community Water Supply (Child Care Provider)	2.8275	80
Non-Community Water Supply (Children's Camp)	2.3135	110
Non-Community Water Supply (Industry)	1.8355	116
Office Building	1.4015	5
Non-Community Water Supply (Medical Care Provider)	0.7095	55
Non-Community Water Supply (Adult Foster Care Provider)	0.0000	6
Non-Community Water Supply (Hotel or Motel)	0.0000	4
Park	0.0000	2
Residential	0.0000	1
Tribal Lands	0.0000	12

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Joining the two data sets (PFAS sites and public_water_max_long)

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

type	total_hazard	n_sites	HFPODA	PFBS	PFHxS	PFNA
Airport	371.4280	15	280	114.0	640	8
Landfill	264.6742	20	93	137.1	526	42
Fire Related	200.9636	12	187	81.8	307	8
Industrial	148.6296	11	0	114.8	363	8
Military	144.0460	9	187	23.0	139	34
Plating	111.6746	8	93	37.3	186	0
Wastewater	93.6640	8	0	32.0	234	0
Paper Manufacturing	76.1160	6	0	58.0	182	8
Unknown	41.6460	4	0	23.0	104	0
Tannery	28.8180	2	0	9.0	72	0
Laundromat/Dry Cleaner	22.0280	4	0	14.0	55	0
MIlitary	8.8000	1	0	0.0	22	0
Refinery	6.8080	1	0	4.0	17	0